Hi,
I have retrieved the rownum value from database using hibernate.Now i want to print that value on a window.how can i do that?
It's urgent.
Thankyou.
I need to have a file for database configuration outside of EAR file of my EJB application. Even if I define a datasource and call it via JNDI, I still have some properties that I want to change, like hibernate.dialect or hibernate.show_sql, for example.
I tried using:
<property name="hibernate.ejb.cfgfile" value="some-file.xml" />
and it works fine when some-file.xml is in jar file, but how to call it from another location. I tried file:/// but didn´t work.
thanks
I'm looking for a database to pair with a node.js app. I'm assuming a json/nosql db would be preferable to a relational db [I can do without any json/sql impedence mismatch]. Considering
couchdb
mongodb
redis
Anyone have any views / war stories re compatiability/deployability of the above with node.js ? Any clear favourites ?
hi all,
Pls guide me how to create rails application using rails 2.3.5 and cassandra database as rails 2.3.5 supports mysql, sqllite etc.
I typed in the command prompt like this
$ rails -d cassandra myapp
Databases supported for preconfiguration are: mysql, oracle, postgresql, sqlite2, sqlite3, frontbase, ibm_db
So pls help me in this regard
Hi All,
When I try to pull a report in Crystal Reports 2008, it gives me error that says Physical database not found in the Report Viewer. As I am new to Crystal reports, could you please explain me how to solve this error
I would like to put a binary file in varbinary(MAX) column using _RecordsetPtr in a vc++ application.I am sure that lot of people have done this before. But I am new to database programming. Help is urgently needed ...Thanks in advance.
I have a mysql database which allocate:
iid, name, description, url, namecategory, idcategory, nametopic, idtopic
How can i know the number of entries that has categoryid=1 and topicid=1?
I've try
$result = mysql_query("SELECT COUNT(id) FROM videos WHERE categoryid=1 AND topicid=1")
But it hasn't worked!
My project is like a classifieds kind of stuff..
I have a search text box in the first page.
When the user enters some text in that, i need to compare that text to the XML file from where all the data are being recieved, and should list out all the advertisements in the Table View (next page)..
I had did this kind of search in sql database..but not with XML..
Just need some help..
Hi I need some sample SQL Server Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample.
Can any body help ?
In-process HSQLDB database are not expected to be opened by others, even for file-based storage.
The documentation hints that this is possible: Server Modes, Advanced Topics, but I've not yet found a URL for how to activate this behaviour.
Did anyone do this so they can share how to?
We are in the process of moving databases from older 32 bit hardware running sql 2005 to newer hardware with sql 2008 64 bit. My question is if the database is automatically converted to 64bit after it is reattached on the new server or if it is running in 32bit mode on a 64bit instance. Is there a way to tell?
As the name says, force the alter database to alter its collation ignoring the error message that I get from functions or calculated columns that compare data.
Is there a way to do so?
Like IGNORE_ERRORS or something like that?
Thanks a lot!
sir,
l want to display resultset in jframe.i get output last record in the database displayed.
Lam intrested to place next button,back button in the frame.when i was click in the back button previosly viewed record is displayed and vice-versa.i don't know it will be possible.plz help me
Hi, I ve forgot what i set as username and password for mysql database. How could I be able to find it out.I am using wamp server. I am a newbie in mysql and its time to get started for my first project.Please help.
I have a large database with over 150 tables that I've recently been handed. I'm just wondering if there is an easy way to view all foreign key constraints for the entire DB instead of on a per-table basis.
I have a MS SQL 2008 database in 3NF.
I must check if the db can support many concurent users.
Which is the best method ?
[Is there any free tool to do this ?]
Thank you very much.
What is the best way to shred XML data into various database columns? So far I have mainly been using the nodes and value functions like so:
INSERT INTO some_table (column1, column2, column3)
SELECT
Rows.n.value('(@column1)[1]', 'varchar(20)'),
Rows.n.value('(@column2)[1]', 'nvarchar(100)'),
Rows.n.value('(@column3)[1]', 'int'),
FROM @xml.nodes('//Rows') Rows(n)
However I find that this is getting very slow for even moderate size xml data.
Hi I am having Netezza Database. I am querying the tables through DB visualiser. Since my table creation involves complex, I am interested to use procedures but I am unable to write it in DBvisualiser. I am confused whether the problem is with the tool that I use or in Netezza? Please advice
I'm working in NetBeans 6.8 and I'm trying to create new connection using MySQL to an existing database. Does the .mdb file need to be in a specific location? It tells me that it cannot establish the connection.
We put our website advertisement in 2 other websites. We need to count the hits we are getting form those advertisement and like to store it in my database. Please give me an idea to do that.
We are doing a migration of our Sybase database that has a utf8 encoding to a server with iso 1 encoding. We are just using char and Varchar for our strings. Will doing backup and restore not truncate any strings? I was thinking that Char and Varchar are just single byte characters.
Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary
(I am not trying to do an upload form)
Any clue on the way to do that ?
Thank you
I have a web service that I just coded up that drops an image (png) into my SQL Server 2008 database as a varbinary.
Is there a easy tool out there that can let me see that image?
I could code up a client, but I would rather just use a tool if one exists.
I have a table in the same database as my wordpress install. What is the correct way of querying it the "wordpress way" ? I know I can use mysqli and that is what I usually do. But I am sure wordpress has it's own standard and perhaps classes to do this.
thanks