Hey there,
I looked at some other posts, many guys have the same problem: I can connect to the oracle database successfully via the following properties file (snippet):
# # -------------- SETTINGS FOR ORACLE --------------------
#
# # These are the settings for use with the Oracle database.
#
# # hostname and port where the database server is installed
sql.Oracle.interface.type: dataSource
sql.Oracle.driver: oracle.jdbc.pool.OracleDataSource
sql.Oracle.driver.serverName: xyz.abc.de
sql.Oracle.driver.portNumber: 1521
#
# # SID of Oracle Database
sql.Oracle.driver.databaseName: ABCDE
#
# # username and password that can create and modify tables in that database
# # this user must have the following privileges for the system to function
# # properly: create/alter/drop table; create/drop sequences;
# # insert/update/replace/delete rows.
sql.Oracle.driver.user: SYS as SYSDBA
sql.Oracle.driver.password: SYS
It works perfectly! Also the JNDI connection works perfectly within the Container (by the way: we use WebSphere AS 6.1)
But I cannot connect through JNDI! If I try it through the admin console, an error eccours - InitialContext problem (as in the other posts). I cannot find a JNDI name in Visual Builder - although the connection works, I see my database tables in the "DataSources"-Window....
So please please please please:
Give us an example properties file. Not again a hint that we should use this tool or that gui builder. I just want to see an example property file for a Oracle or MySQL database connection through JNDI.
Which properties are necessary? Which are not?
If you post such an example, we can be sure, that it is only a JNDI-name problem and we can try out different combinations with and without prefixes, backslashes and so on...
Because there is no documentation for this, you should be able to post such file? That would be great and help me and many other users a lot...
Thank you !!!
best regards,
Kai
I looked at some other posts, many guys have the same problem: I can connect to the oracle database successfully via the following properties file (snippet):
# # -------------- SETTINGS FOR ORACLE --------------------
#
# # These are the settings for use with the Oracle database.
#
# # hostname and port where the database server is installed
sql.Oracle.interface.type: dataSource
sql.Oracle.driver: oracle.jdbc.pool.OracleDataSource
sql.Oracle.driver.serverName: xyz.abc.de
sql.Oracle.driver.portNumber: 1521
#
# # SID of Oracle Database
sql.Oracle.driver.databaseName: ABCDE
#
# # username and password that can create and modify tables in that database
# # this user must have the following privileges for the system to function
# # properly: create/alter/drop table; create/drop sequences;
# # insert/update/replace/delete rows.
sql.Oracle.driver.user: SYS as SYSDBA
sql.Oracle.driver.password: SYS
It works perfectly! Also the JNDI connection works perfectly within the Container (by the way: we use WebSphere AS 6.1)
But I cannot connect through JNDI! If I try it through the admin console, an error eccours - InitialContext problem (as in the other posts). I cannot find a JNDI name in Visual Builder - although the connection works, I see my database tables in the "DataSources"-Window....
So please please please please:
Give us an example properties file. Not again a hint that we should use this tool or that gui builder. I just want to see an example property file for a Oracle or MySQL database connection through JNDI.
Which properties are necessary? Which are not?
If you post such an example, we can be sure, that it is only a JNDI-name problem and we can try out different combinations with and without prefixes, backslashes and so on...
Because there is no documentation for this, you should be able to post such file? That would be great and help me and many other users a lot...
Thank you !!!
best regards,
Kai
Comment