Most SQL is same and it supports a subset of SQL 92 and SQL 99 standards. Every RDBMS vendor have some proprietory code which dont work in other databases. There is one RDBMS Firebird(http://firebird.sourceforge.net/). The site claims that it is more like Oracle.
rgds Antony Paul On Mon, 21 Feb 2005 23:01:40 -0800 (PST), U K Laxmi <[EMAIL PROTECTED]> wrote: > Thank you for the replies. Ms Access is not a > relational databaase. It's just DBMS. I didn't know > that PostGreSQL is a open source RDBMS system. All the > sqls, table creation etc.. works similar to Oracle or > any other RDBMS? I'm working on windows 2000 machine. > > --- Antony Paul <[EMAIL PROTECTED]> wrote: > > > I dont whether MS Access is considered as RDBMS. For > > serious > > development it is not recommended. Using ODBC have > > several problems. I > > will recommend PostgreSQL. Now it runs very well on > > Windows. But > > requires Windows 2000 or higher. You can find it at > > http://www.postgresql.org/ftp/binary/v8.0.1/win32/. > > I am using it and have no problems. I am posting > > my configuration > > that I used to set up DBCP. > > > > server.xml > > ----------------------------------- > > <GlobalNamingResources> > > > > <!-- Test entry for demonstration purposes --> > > <Environment name="simpleValue" > > type="java.lang.Integer" value="30"/> > > > > <!-- Editable user database that can also be > > used by > > UserDatabaseRealm to authenticate users --> > > <Resource name="UserDatabase" auth="Container" > > > > type="org.apache.catalina.UserDatabase" > > description="User database that can be > > updated and saved" > > > > > factory="org.apache.catalina.users.MemoryUserDatabaseFactory" > > pathname="conf/tomcat-users.xml" /> > > > > <Resource name="jdbc/db1" auth="Container" > > type="javax.sql.DataSource" > > > > > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > > driverClassName="org.postgresql.Driver" > > > > url="jdbc:postgresql://192.168.4.248/antony" > > maxActive="20" maxIdle="10" maxWait="-1" > > > > username="benchmark" > > password="benchmark" > > /> > > > > </GlobalNamingResources> > > > > > > TOMCAT_HOME/conf/context.xml > > --------------------------------------------------- > > <ResourceLink global="jdbc/db1" name="jdbc/db1" > > type="javax.sql.DataSource"/> > > > > TOMCAT_HOME/webapps/web/WEB-INF/web.xml > > > ----------------------------------------------------------------------------- > > <resource-ref> > > <res-ref-name>jdbc/db1</res-ref-name> > > <res-type>javax.sql.DataSource</res-type> > > <res-auth>Container</res-auth> > > </resource-ref> > > > > > > > > Did you defined your newly created context web in > > server.xml or at > > TOMCAT_HOME\conf\Catalina\localhost\some name.xml > > > > hope it will help. > > > > rgds > > Antony Paul > > > > > > > > On Mon, 21 Feb 2005 22:25:59 -0800 (PST), U K Laxmi > > <[EMAIL PROTECTED]> wrote: > > > Yes i read and did as per the document. When it > > didn't > > > work, i followed the suggetions given to many > > users in > > > the mailing lists in the internet and now i guess > > i > > > messed up. Actually in the error, it says, no > > suitable > > > driver found. > > > > > > I'm using Ms Access as it's free. Do we have any > > free > > > driver available in the form of jar to use in > > place of > > > JDBC-ODBC bridge driver? Or it's not required if > > > configuration is correct. Pls let me know. I've > > pasted > > > all relevant code in my first mail itself. If time > > > permits, any of you can try & give me the > > solution. > > > It'll be a great help. > > > > > > I've integrated tomcat 5.5.7 with apache 2. Does > > this > > > has any impact on the above. > > > > > > --- Antony Paul <[EMAIL PROTECTED]> wrote: > > > > > > > If you followed the tomcat docs you will have no > > > > problem in DBCP > > > > getting to work. Going for Globalnamingresources > > is > > > > needed if you need > > > > to access it will all applications. Try to > > configure > > > > it as per the doc > > > > in following URL. > > > > > > > > > > > > > > http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html > > > > > > > > follow MySQL config. And no need to put > > commons*.jar > > > > in commons/lib as > > > > TC by default comes with it. > > > > > > > > rgds > > > > Antony Paul > > > > > > > > > > > > On Mon, 21 Feb 2005 21:52:13 -0800 (PST), U K > > Laxmi > > > > <[EMAIL PROTECTED]> wrote: > > > > > I tried without GlobalNamingResources. No > > luck. > > > > When > > > > > googled, i found that if we include > > > > > GlobalNamingResource tag, then it will be > > > > available in > > > > > all web context. > > > > > > > > > > After spending enough time on that, now i > > coded > > > > all > > > > > database related stuff in JSP in the way we do > > in > > > > > stand alone application. I mean - > > > > > > > > > > Coding like this in jspo itself. > > > > > > > > > > ---- code -- > > > > > <%@ page contentType="text/html" > > > > import="java.sql.*"%> > > > > > > > > > > <html> > > > > > > > > > > <head><title>simmPlan - simple material > > planning > > > > > system</title> > > > > > <script language="JavaScript" > > > > > src="/js/default.js"></script> > > > > > > > > > > <% > > > > > > > > > > String userid = > > request.getParameter("userid"); > > > > > String passwd = > > request.getParameter("passwd"); > > > > > System.out.println("Password: " + passwd); > > > > > String pwd = "", str = ""; > > > > > int level = -1, ind = -1; > > > > > > > > > > try { > > > > > Connection conn = null; > > > > > > > > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > > > > > > > > > > > > > > > > > > > conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft > > > > > Access Driver > > > > > (*.mdb)};DBQ=C:/tomcat/webapps/db1/db1.mdb"); > > > > > Statement stmt = > > > > > conn.createStatement(); > > > > > > > > > > String query = "SELECT * FROM > > user > > > > > where name = '" + userid + "'"; > > > > > > > > > > ResultSet st = > > > > > stmt.executeQuery(query); > > > > > if (st.next()) { > > > > > pwd = > > > > st.getString("password"); > > > > > > > > > > level > > = > > > > st.getInt("level"); > > > > > System.err.println("Query > > > > > result="+userid+"/"+pwd+"/"+level); > > > > > } > > > > > else { > > > > > ind = > > -2; > > > === message truncated === > > __________________________________ > Do you Yahoo!? > The all-new My Yahoo! - Get yours free! > http://my.yahoo.com > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]