Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2880789
By: ann04
Hello,
I am using dbforms_2.4,
I created dbforms-config.xml file using DevGUI tool, and when I tested the
connection
to my Oracle Db, it was successfull.
But when I call my menu.jsp from browser, I get this error message:
"java.lang.IllegalArgumentException: JDBC-Troubles: was not able to create
connection from DbConnection = id=null,
name=jdbc:oracle:thin:@machineName:1521:DBName, jndi=false,
conClass=oracle.jdbc.driver.OracleDriver, username=usr, default=true
"
Here is my dbforms-config code:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<dbforms-config>
<dbconnection
name = "jdbc:oracle:thin:@machineName:1521:DBName"
isJndi = "false"
conClass = "oracle.jdbc.driver.OracleDriver"
username = "usr"
password = "pwd"
/>
<table name="CUSTOMER0"
defaultVisibleFields="CUSTOMER_ID" >
<field name="CUSTOMER_ID" fieldType="char" size="64"
isKey="true"/>
<field name="C_FULL_NAME" fieldType="char" size="128"/>
<field name="C_ADDRESS" fieldType="char" size="510"/>
<field name="C_PASSWORD" fieldType="char" size="32"/>
<field name="CUST_PRFL_ID" fieldType="char" size="64"/>
<field name="C_BALANCE" fieldType="integer" size="18"/>
<field name="C_BAL_CRNCY" fieldType="char" size="3"/>
<field name="TXN_LIMIT_ID" fieldType="integer" size="22"/>
<field name="C_TXN_COUNTER" fieldType="integer" size="22"/>
<field name="C_DISABLED" fieldType="char" size="1"/>
<field name="C_FREETEXT" fieldType="char" size="1024"/>
<field name="TXN_ID" fieldType="integer" size="22"/>
<field name="C_TIMESTAMP" fieldType="date" size="7"/>
<!-- add "granted-privileges" element for security
constraintegers -->
</table>
<!-- ========== Connection =================================== -->
<!--
uncomment this if you have access to JNDI of an application server (see
users
guide for more info)
<dbconnection
name = "jdbc/dbformstest"
isJndi = "true"
/>
-->
</dbforms-config>
menu.jsp code:
<%@ taglib uri="/WEB-INF/dbForms.tld" prefix="db" %>
<html>
<head>
<db:base/>
</head>
<body>
<h1>Menu</h1>
<db:dbform followUp="/menu.jsp">
<center>
<p>
<db:gotoButton caption="Edit services" destination="/service.jsp"
destTable="customer0"/>
</p>
</center>
</db:dbform>
</body>
</html>
I tried the colution posted earlier, like puting dbconnection tag on top and
changin field types,but nothing helped so far.
Please help!
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=55830
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
