Database connection error | created a new datasource | web application

[Former Member]

Hi,

I am trying to deploy a J2EE web application on SAP Netweaver 7.0. I have to connect to a Oracle database schema (Not the default schema used by SAP). I am using Java and JDBC to make connections to the database.

In order to accomplish this, I created a new data source in Visual Admin. Referenced this in the web.xml and deployed the application. The application is deployed successfully, without any errors or warnings.

However, when ever the Java program connects and executes a prepared statement, I get this error in the database logs

bc.direct.DirectPreparedStatement#Java#com.sap.sql_0003#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection xxxx111:xxx:xxx: code=942, state="42000", message="ORA-00942: table or view does not exist

";

SQL statement is "SELECT "XMLVALUE" FROM "BC_DDDBTABLERT" WHERE "NAME" = ?".#5#942#42000#ORA-00942: table or view does not exist

#solad011:pidb:PIUSER#SELECT "XMLVALUE" FROM "BC_DDDBTABLERT" WHERE "NAME" = ?#

In java code, there are no references to this table "BC_DDDBTABLERT". I am trying to execute a SQL select for entirely different table. Why I am I getting this error?

[Former Member]

Hi,

I managed to solve the problem. In Visual Administrator, for the new datasource, I changed the current option "Open SQL" to --> "Native SQL"

Now I am able to query the tables from the new schema.

[Former Member]

Hi,

System copy NW 70 - Error in "export from java database" phase

I am doing system copy of BI7.0 (Abap+Java) stack, I am getting error in

"export from java database" phase as mentioned below.

When I tried to run the query mentioned in SAP Note 1120872: ,

SQL> DELETE FROM BC_DDDBTABLERT WHERE NAME = 'CAF_GP_R3USRMPGCFG';

DELETE FROM BC_DDDBTABLERT WHERE NAME = 'CAF_GP_R3USRMPGCFG'

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> DELETE FROM BC_DDDBTABLERT WHERE NAME = 'CAF_GP_IF_CONTEXT';

DELETE FROM BC_DDDBTABLERT WHERE NAME = 'CAF_GP_IF_CONTEXT'

*

ERROR at line 1:

ORA-00942: table or view does not exist

I tried your Native_SQL also, but same error.

Kindly help me on this.

Regards,

Sampath.

SAP INST error log:

ERROR 2010-10-15 10:32:35

CJS-30049 Execution of JLoad tool '/usr/java/j2sdk1.4.2_12/bin/java

-classpath /usr/sap/BD1/SYS/global/sltools/sharedlib/launcher. jar

-showversion -Xmx512m com.sap.engine.offline.OfflineToolStart

com.sap.inst.jload.Jload

/usr/sap/BD1/SYS/global/security/lib/tools/iaik_jce .jar:/usr/sap/BD1/SYS/global/security/lib/tools/ia ik_jsse.jar:/usr/sap/BD1/SYS/global/security/lib/tools/ia ik_smime.jar:/usr/sap/BD1/SYS/global/security/lib/tools/ia ik_ssl.jar:/usr/sap/BD1/SYS/global/security/lib/tools/w3 c_http.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/jlo ad.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/ant lr.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/exc eption.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/jdd i.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/log ging.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/off lineconfiguration.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/ope nsqlsta.jar:/usr/sap/BD1/SYS/global/sltools/sharedlib/tc_ sec_secstorefs.jar:/oracle/client/10x_32/instantclient/ojdbc14.j ar

-sec

BD1,jdbc/pool/BD1,/usr/sap/BD1/SYS/global/security /data/SecStore.properties,/usr/sap/BD1/SYS/global/ security/data/SecStore.key

-dataDir /oracle/expocopy/JAVA/JDMP -remove_trailing_blanks

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/removeTrailingBlanks.txt

-convert_empty_LOBs

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/convertEmptyLobs.txt

-convert_empty_strings

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/convertEmptyStrings.txt

-convert_empty_binary

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/convertEmptyBinary.txt'

aborts with return code 1.<br>SOLUTION: Check 'jload.log' and

'/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/jload.java.log'

for more information.

Log details for jload.java.log:

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

Oct 15, 2010 10:32:33 AM com.sap.inst.jload.Jload main

INFO: Jload -sec

BD1,jdbc/pool/BD1,/usr/sap/BD1/SYS/global/security /data/SecStore.properties,/usr/sap/BD1/SYS/global/ security/data/SecStore.key

-dataDir /oracle/expocopy/JAVA/JDMP -remove_trailing_blanks

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/removeTrailingBlanks.txt

-convert_empty_LOBs

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/convertEmptyLobs.txt

-convert_empty_strings

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/convertEmptyStrings.txt

-convert_empty_binary

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/convertEmptyBinary.txt

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.db.DBConnection

connectViaSecureStore

INFO: connected to BD1 on jdbc/pool/BD1

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type TB): [EP_ATTR_HEADERS, EP_ATTR_VALUES,

J2EE_CONFIGENTRY]

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type EL): [EP_ATTR_HEADERS, KMC_DBRM_CONTENT,

EP_ATTR_VALUES, J2EE_CONFIGENTRY]

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type ES): [EP_ATTR_HEADERS, KMC_DBRM_CONTENT,

BC_SCVERSION, J2EE_CONFIGENTRY]

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type EB): [KMC_DBRM_CONTENT, J2EE_CONFIGENTRY]

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.JobStatus readStatus

INFO: trying to read status file

/tmp/sapinst_instdir/NW04S/LM/COPY/ORA/EXP/CENTRAL/ AS/EXP/EXPORT.sta

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.Jload dbExport

SEVERE: DB Error during export of CAF_GP_IF_CONTEXT

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.Jload printSQLException

SEVERE: Message: ORA-00942: table or view does not exist

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.Jload printSQLException

SEVERE: SQLState: 42000

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.Jload printSQLException

SEVERE: ErrorCode: 942

Oct 15, 2010 10:32:35 AM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

[Former Member]

No double posting please!

And please do not hijack old threads that are only just a bit similar to your problem!