oracle - Glassfish 3 Connection Pool throws java.sql.SQLSyntaxErrorException: ORA-00933 -

-

iam using glassfish 3 server run web service. connection pool implemented in server , able ping database.

connection received server throwing java.sql.sqlsyntaxerrorexception: ora-00933: sql command not ended exception while running preparedstatement.

glassfish 4 not throw exception

the query taken property file

query=select * table systemid=?1

using 2 seperate java classes receiving connection , further processing

jdbcutil.java

public static connection connectionfromconnectionpool()         throws namingexception, sqlexception {     context initctx = new initialcontext();     datasource datasource = (datasource) initctx.lookup(propertyfilereader                             .getpropertyvalue("connectionpool.jndi.name"));     connection connection = (connection) datasource.getconnection();     if (connection != null) {         logger.info("received connection");     } else {         logger.info("no connection received");     }      return connection; }

dao.java

resultset resultset = null;     preparedstatement preparedstatement = null;     connection connection = null;     try {         connection = jdbcutil.connectionfromconnectionpool();          if (connection != null) {             preparedstatement = connection                     .preparestatement(propertyfilereader                             .getpropertyvalue("query"));             if (preparedstatement != null) {                 preparedstatement.setstring(1, "systemid");                 resultset = preparedstatement.executequery();     // line no:56

log generated :

18:13:35,328 info - *****.jdbcutil.connectionfromconnectionpool(jdbcutil.java:38) - received connection 18:13:35,397error - *****(dao.java:81) - **************************** ::  java.sql.sqlsyntaxerrorexception: ora-00933: sql command not ended  @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:440) @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:396) @ oracle.jdbc.driver.t4c8oall.processerror(t4c8oall.java:837) @ oracle.jdbc.driver.t4cttifun.receive(t4cttifun.java:445) @ oracle.jdbc.driver.t4cttifun.dorpc(t4cttifun.java:191) @ oracle.jdbc.driver.t4c8oall.dooall(t4c8oall.java:523) @ oracle.jdbc.driver.t4cpreparedstatement.dooall8(t4cpreparedstatement.java:207) @ oracle.jdbc.driver.t4cpreparedstatement.executefordescribe(t4cpreparedstatement.java:863) @ oracle.jdbc.driver.oraclestatement.executemaybedescribe(oraclestatement.java:1153) @ oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1275) @ oracle.jdbc.driver.oraclepreparedstatement.executeinternal(oraclepreparedstatement.java:3576) @ oracle.jdbc.driver.oraclepreparedstatement.executequery(oraclepreparedstatement.java:3620) @ oracle.jdbc.driver.oraclepreparedstatementwrapper.executequery(oraclepreparedstatementwrapper.java:1491) @ com.sun.gjc.spi.jdbc40.preparedstatementwrapper40.executequery(preparedstatementwrapper40.java:642) @ *************************************(dao.java:56) ....................

ojdbc6.jar placed in glassfish3\glassfish\lib , glassfish4\glassfish\lib

check if there other ojdbc jar inside server folder inside domain folder using.

if there different jars or different versions of jar in server folder, may cause such errors.

for ex : glassfish3\glassfish\domains\domain1\lib...

if there jar files of different versions, replace them same version.

i use glassfish4. kept ojdbc jar in glassfish4\glassfish\lib works fine me.


Comments

Post a Comment

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

-
i have a little website header no longer renders correctly, since updating firefox 38.0.5 [the faceplant logo missing top right, , main logo no longer centred]. still renders expected in other browsers. how has engine's rendering changed in update? according mdn , list of changes is: css support ruby-position , ruby-align have been added , available default ( bug 1055676 , bug 1123917 , bug 1039006 ). the :unresolved pseudo-class has been implemented custom elements ( bug 1111633 ). the predefined style ethiopic-numeric uses space, instead of dot, suffix match recent change spec ( bug 1120721 ). css transitions on generated content (with ::before , ::after ) on both inline , block splits them start expected specification ( bug 1110277 ). the implementation of css logical properties made big progress. [...] how css transitions start has been modified match recent change of specifications, aiming @ having interoperable behavio...
Read more

android - CollapsingToolbarLayout: position the ExpandedText programmatically -

-
i using new android support design view collapsingtoolbarlayout. have need position expandedtitle programmatically. actually way set position expandedtitle in .xml file (example here: https://goo.gl/l5h5fc ) there no public api set text position programmatically , fields private . do know if it's possible without reflection or 'hacky' tricks? i have solved problem exposing properties via reflection ( https://gist.github.com/fpezzato/8e7d45112883dbbc5ffb ), works don't use trick in production code. @google: please no more private or final stuff! :)
Read more

c# - Where does the .ToList() go in LINQ query result -

-
when getting data populate data grid, have pulled data, made list , mapped model, this: public list<person> getpeople() { var data = _db.person.tolist(); list<person> people = new list<person>(); foreach (var item in data) { person person = new person() { personid = item.personid, firstname = item.firstname, lastname = item.lastname }; people.add(person); } return people; } this works fine, in interest of writing less code discovered .select method , (what think is) anonymous type. have: public list<person> getpeople() { return _db.person.select(d => new person { personid = item.personid, firstname = item.firstname, lastname = item.lastname }).tolist(); } though not easy read, works fine too. there preference either way? ...
Read more